Categories

Versions

Select Attributes (In Database) (In-Database Processing)

Synopsis

Filters the list of columns of the current data set.

Description

This operator only keeps certain columns according to its parameters.

Input

  • example set input

Output

  • example set output

Parameters

  • attribute filter type The condition specifies which attributes are selected or affected by this operator.
  • attribute The attribute which should be chosen.
  • attributes The attribute which should be chosen.
  • regular expression A regular expression for the names of the attributes which should be kept.
  • use except expression If enabled, an exception to the specified regular expression might be specified. Attributes of matching this will be filtered out, although matching the first expression.
  • except regular expression A regular expression for the names of the attributes which should be filtered out although matching the above regular expression.
  • value type The value type of the attributes.
  • use value type exception If enabled, an exception to the specified value type might be specified. Attributes of this type will be filtered out, although matching the first specified type.
  • except value type Except this value type.
  • block type The block type of the attributes.
  • use block type exception If enabled, an exception to the specified block type might be specified.
  • except block type Except this block type.
  • numeric condition Parameter string for the condition, e.g. '>= 5'
  • invert selection Indicates if only attributes should be accepted which would normally filtered.